from bigScreenDigitalPeople.bigScreen.chit_chat import WriteExcel

# show_radius = ["查看一下", "展示一下", "我想看看", "帮我统计一下"]
show_radius = ["查查","帮我查查","统计一下","我想知道"]
# time_radius = ["从前天到今天", "从昨天到今天", "从前天到昨天", "最近5天", "最近一周", "最近一个月",
#                "最近五天每日","最近五天每一天",
#                "从上周1到上周5", "从上周1到本周1", "从本周1到本周2", "从上周2到前天", "从上周2到昨天", "从上周2到今天",
#                "从8月25号到9月1号", "从8月25号到前天", "从8月25号到昨天", "从8月25号到今天",
#                "从上个月1号到今天", "从上个月1号到昨天", "从上个月1号到前天", "从上个月1号到本周1", "从上个月1号到上周1", "从上个月1号到这个月1号"]
time_radius = ["最近五天","最近五天每一天","今天","今天上午3点到下午5点","今天每小时",]



region_radius = ["", "科学城"]
event_radius = ["闯红灯", "非机动车闯红灯", "机动车闯红灯","非机动车闯红灯和机动车闯红灯"]
statistical_type = ["事件的数量", "变化趋势", "在所有事件中的占比情况", "事件数量和占比", "事件的排名"]


def main(write_obj):
    row_num = 1
    for i in show_radius:
        for j in time_radius:
            for k in region_radius:
                for l in event_radius:
                    for m in statistical_type:
                        # print(i+j+k+l+m)
                        print(j+k+l+m)
                        write_obj.write_excel_body(row_num, 3, i + j + k + l + m)
                        write_obj.write_excel_body(row_num, 0, "数据分析")
                        write_obj.write_excel_body(row_num, 1, "智能分析")
                        write_obj.write_excel_body(row_num, 2, "数据分析")
                        row_num += 1
    write_obj.save_excel("数据分析类指令")

def fenxi():
    for j in time_radius:
        for k in region_radius:
            for l in event_radius:
                for m in statistical_type:
                    print(j+k+l+m)

fenxi()


if __name__ == '__main__':
    write_obj = WriteExcel("数据分析类指令")
    write_obj.write_excel_head("指令类型","预期type","预期method","指令","实际type","实际statistic.content","result")
    main(write_obj)












